﻿CREATE TABLE [dbo].[ASMS_ServiceItem]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[CategoryId] uniqueidentifier NOT NULL,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[Code] nvarchar(32) NOT NULL,
	[Name] nvarchar(64) NOT NULL,
	[Pinyin] nvarchar(64),
	[Letter] nvarchar(16),
	[Status] int,
	[SortIndex] int,
	[Price] MONEY,
	[Discount] MONEY,
	[TaxRate] MONEY,
	[SalesCommission] MONEY,
	[SalesCommissionType] int,
	[TechnicianCommission] MONEY,
	[TechnicianCommissionType] int,
	[CreatedTime] datetime,
	[Creator] nvarchar(64)
)
